EMT Practice Test

1. Question Content...

---

Question1: If there is more than one rule in the rules file for a given cell, which rule does IBM CognosTM1 calculate?

Question2: Following TM1 best practices for budget applications, which dimension omits consolidated elements?

Question3: Click the Exhibit button.

Referring to the exhibit, a rule is written where the sales_amt is equal to units multiplied by avg selling price
What does the cube view tell you about the rule calculation?

Question4: A Skipcheck statement appears in the Rules file, however the calculated cells are not fed. What are two results? (Choose two.)

Question5: Which two attributes are aliases on a large product dimension? (Choose two.)

Question6: What are three examples of privileges that can be assigned to TM1 objects? (Choose three.)

Question7: You are asked to use Performance Modeler to Transfer a cube. The target cube already exists in the target system but the source cube contains an additional dimension.
What happens to the target cube and its data?

Question8: You want to load data to Cube A that will result in faster load times while ensuring TM1 can recover the content of the data load in the event of a subsequent server failure.
Which technique would you use?

Question9: In a Turbolntegrator process, you need to create a cube structure before loading data into it. In which tab would you create the cube?

Question10: A TM1 Action Button can directly perform which two tasks? (Choose two.)

Question11: You are concerned about overfeeding in a TM1 model.
What are two symptoms of this? (Choose two.)

Question12: You setup a chore to run nightly at 9:00 p.m. The T1 process requires specific parameters to be set.
Where do you specify the parameters so that they are applied by the chore?

Question13: Click the Exhibit button.

You have the dimension shown in Performance Modeler as shown in the exhibit.
Which three actions create a subset containing the countries starting with "A" in alphabetical order?
(Choose three)

Question14: Which statement is true for TM1 dimensions?

Question15: Which action must you take before the TM1 cubes can be used in IBM Cognos B1?

Question16: If vOriginalDate = July 27, and you require vNewDate = Jul2012, which syntax is appropriate to complete this task?

Question17: Click the Exhibit button.

Using Performance Modeler, items are set either from an amount which is brought in from another cube by a link or from a calculation (quantity times price). During testing, all the items are quantity times price. The relevant part of the rules file is shown in the exhibit.
How do you change the rules so that the items are set to the amount where required?

Question18: You have developed a sequence of T1 processes connected together by the ExecuteProcess(..) command. To improve the performance of the application, you decide to break up the sub-processes so that they run in their own thread to use cores more efficiently.
Which TM1 object accomplishes this goal?

Question19: Which three are typically stored within a TM1 control object? (Choose three.)

Question20: In which TM1 cube would a developer define dimension hierarchy levels for use in IBM Cognos B1 reporting?

Question21: Which two statements are true about predefined administrator groups? (Choose two.)

Question22: A customer is using dynamic subsets.
Which statement is true about TM1 Perspectives?

Question23: What does IBM Cognos TM1 do with calculated values based on rules?

Question24: An international enterprise has planners in European, Asian, and North American regions. The enterprise wants to have planners in each region enter cube data into the local regional TM1 server but report globally on a daily basis from a single enterprise-reporting server located in Canada. The enterprise wants to integrate the cube data from the different regions into a single reporting server in Canada.
Which method accomplishes this goal?

Question25: You need to import new monthly sales data into an existing cube.
Using the Turbolntegrator wizard, which action will load the data while maintaining the cube structure?

Question26: Which statement is true when using Cognos Access Manager (CAM) User Authentication with TM1?

Question27: When creating TM1 applications using Performance Modeler, what are the three legal values for Application Type? (Choose three.)

Question28: User security assignments are stored in which control cube?

Question29: You execute a number of Turbolntegrator processes as part of a chore using the ExecuteProcess function but errors result. Upon reviewing the log files, inadequate information about the errors exist.
What is the debugging strategy?

Question30: Cross-Cube Feeder statements will result in a Cube Dependency relationship between the Dependent Cube (containing the feeder) and the Base Cube (the target cube of the Feeder from the Dependent Cube) if the Feeding cells contain data at Server startup or if initially null at server startup, the feeding cells are subsequently updated during the server session.
Which statement describes the relationship between the cubes having the Cube Dependency relationship?

Question31: Click the Exhibit button.

Referring to the entries in the tm1server.log shown in the exhibit, which statement is correct?

Question32: You want to export only user-entered non-zero numeric values from a cube.
Which three view manipulation functions are required? (Choose three.)

Question33: Which three parameters create a view extract of a cube either manually or when using Turbolntegrator?
(Choose three.)

Question34: You are developing a TM1 model for a city aquarium and must add these new elements to the Animal dimension: Amphibians. Frog, and Salamander. Assume that Amphibians is the parent of Frog and Salamander and that you want the children to automatically roll up to the parent.
Which weighting and element type will you assign to each element?

Question35: You have a cube which contains four regions, North, South, East, and West. You want to clear all data from the West region.
Which method accomplishes this goal?

Question36: A TM1 Operations Console shows a thread which is waiting to obtain a read lock on a cube.
Which thread is blocking it?

Question37: What are the elements of a rule?

Question38: In Turbolntegrator, as part of the monthly data load, you need to add new products and their sales values but the products do not exist within the Product dimension in the cube.
Which function would you use to first add the new products to the Product dimension?

Question39: Active Forms support which three features? (Choose three.)

Question40: Your customer requires that all users be forced to collect their data and commit only a whole set of data.
They are not allowed to create different versions.
Which setting is required to fulfill this requirement?

Question41: You want to improve one TM1 cube by adding Skipcheck and Feeder statements to a Rules file. Which statement is correct?

Question42: The Rule Tracer can be used with which TM1 interface?

Question43: Which statement is true about cube properties?

Question44: What are three legal selection criteria for TM1 subsets? (Choose three.)

Question45: Which component would you use to define and publish a package in IBM Cognos Bl to report from TM1 data?

Question46: You have three elements (A, B, and C) of a dimension in a public subset called THE_SUB. You want to address them in an Area Definition in a rule.
Which syntax should you use?

Question47: Regarding the persistence of Local, Global, and User variables, which statement is correct?

Question48: A new member is added to a dimension called Products which is used in a cube called Sales.
What information is recorded in the audit log?

Question49: Within the TM1 cube viewer, which two filter methods are available? (Choose two.)

Question50: Click the Exhibit button.

A user has requested that you create a cube view displaying individual fruit costs by month formatted as currency with two decimal places.
Based on the dimensional information shown in the exhibit, how would you arrange the cube to meet the user's formatting requirement?

Question51: In Cognos Insight, you have a cube containing the following dimensions with the following members.
Products - Pencils, Pens
Regions - North,
South, East, West
Months - Jan, Feb, Mar, Apr, May, Jun, Jul, Aug, Sept, Oct, Nov, Dec
Versions - Actuals, Budget
You need to determine which region did not sell any Pencils in January (Jan).
Where do you need to set explore points?

Question52: Which two statements are true about spreading in TM1? (Choose two.)

Question53: The logging parameter within \}CubeProperties is designated by a "Yes" or "No" for each cube.
What does this define?

Question54: The customer is experiencing performance issues with threads blocking as shown in the TM1 Operations Console.
Which setting within the tmls.cfg file improves writer response time by removing lock contention resulting from concurrent cube data access?

Question55: You develop a new Active Form and would like to format it so that all simple (N-level) cells have a gray background with standard row IDs.
Where do you apply the gray formatting?

Question56: All items are in the same dimension and performance is of the highest priority.
How do you calculate the difference between item A and item B, and then store the result in item C?

Question57: Regarding Sandboxes, why do numbers sometimes appear in blue or green?

Question58: A customer is using TM1 subsets.
Which two statements are true? (Choose two.)